Excel如何设定时间的条件函数,包含If,and,or答:迟到:= IF(F3>TIME(9,30,0),F3-TIME(9,30,0),IF(H3>TIME(14,0,0),H3-TIME(14,0,0),IF(F3<=TIME(9,30,0),0))早退:= IF(((I202-F202)<TIME(4,0,0)),0.5,IF((I202-F202)>TIME(4,0,0),1)))周末加班= IF(((I202-F202)<TIME(4,0,0)),0.5,IF((I202-F2...
请教高手,excel中IF,FIND以及AND,OR嵌套问题!答:改成:=IF(AND(OR(ISNUMBER(FIND("US",AR3)),ISNUMBER(FIND("CA",AR3))),OR(ISNUMBER(FIND("CN",AR3)),ISNUMBER(FIND("JP",AR3)),ISNUMBER(FIND("KR",AR3)),ISNUMBER(FIND("TW",AR3))), OR(ISNUMBER(FIND("DE",AR3)),...